UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Hu23wNvOmg9Xfx8VTsshorN0psTKuUkqnxtlK1GnwY='
WHERE
key_id = '917d4fd94c3aa2786ab304ce17467abc75285f32c834a5662ad6d15a7cfa7534'
AND (
token = '5Hu23wNvOmg9Xfx8VTsshorN0psTKuUkqnxtlK1GnwY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)