UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oAyGchgPzaD6DT0ijun9GtATkC9OroNL7QGeEX1aOUo='
WHERE
key_id = 'bb5d1a97b350977616f7e6903a851226c4756213f3964e2771c184e4e90360c5'
AND (
token = 'oAyGchgPzaD6DT0ijun9GtATkC9OroNL7QGeEX1aOUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)