UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G/HQ3LuIqvKALBBvmJlQ+psNImz95iKGN7WzACMS/5M='
WHERE
key_id = 'e52c96947102110d08e948a5352c2e83a246a308aef628f26c0d83a2bed9e645'
AND (
token = 'G/HQ3LuIqvKALBBvmJlQ+psNImz95iKGN7WzACMS/5M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)