UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qI0BRAexJE7aGTOdX7Y2ejnhId3+D9YMZHeCxPo8ucU='
WHERE
key_id = 'bc66a49e6f5a68aa9455aede0b43720bed1a8fc9184b40a31b736d77e7dd381c'
AND (
token = 'qI0BRAexJE7aGTOdX7Y2ejnhId3+D9YMZHeCxPo8ucU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)