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