UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e4RTJ69XeQuT0+iN3PypOr78TNHmEDQevWpJJkEEZKk='
WHERE
key_id = 'afde8b8a9479e5849a3ade0323fdcc2242b3116d8cec26253cb45992c673efa1'
AND (
token = 'e4RTJ69XeQuT0+iN3PypOr78TNHmEDQevWpJJkEEZKk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)