UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iFGQDLXcMKOQppgz35iD4DmJWa/0PaJDsMXkC92iAZg='
WHERE
key_id = 'a4c0faa7fdcff0b3b0a4b80fbf9b74e7821693d314577dad16160b750edf5409'
AND (
token = 'iFGQDLXcMKOQppgz35iD4DmJWa/0PaJDsMXkC92iAZg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)