UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r1z+rGOEahLf+ukQqPXdh4NoCt4u1iSHuugoJmsKi6w='
WHERE
key_id = '1b159df8df943bc91cd4ad855f8a49c4fa96f23ffe082696794a43d8dea5ef8e'
AND (
token = 'r1z+rGOEahLf+ukQqPXdh4NoCt4u1iSHuugoJmsKi6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)