UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'onuRFl5XCIfbWORZD+IvHltEoyqCuOYVwsbRsN5dIaU='
WHERE
key_id = 'a7b003f1c8343505f1b7722f6d23d138a8d7691fe751acaf689ca4fb4997d0d4'
AND (
token = 'onuRFl5XCIfbWORZD+IvHltEoyqCuOYVwsbRsN5dIaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)