UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TBgFgouvbDnQnFpeaMT/Uow8Qnr8/ja39CtA+djX0WM='
WHERE
key_id = 'ab4bf2a2669ee747a1320f74eb0145ef02fa33a38f8963fe6dee13903a8a0f5d'
AND (
token = 'TBgFgouvbDnQnFpeaMT/Uow8Qnr8/ja39CtA+djX0WM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)