UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lTaTx9JZcz1M9ZBrOCpmWr7MdtU8cIEc4aVy+XeORrw='
WHERE
key_id = 'f4c356635d9695921a7f1ef41b782818de9c77ff0800b891ad418e51922a9fe4'
AND (
token = 'lTaTx9JZcz1M9ZBrOCpmWr7MdtU8cIEc4aVy+XeORrw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)