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