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