UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cOcwz8BT2WixnI4l7nibfzomsGKvCAyw8vPXc9S7aGs='
WHERE
key_id = '995ba0f412c6b6cf6868f04d228158183a4797361434b9630ac938eb5cf6f8b4'
AND (
token = 'cOcwz8BT2WixnI4l7nibfzomsGKvCAyw8vPXc9S7aGs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)