UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6+ly4TeSu5UwYq4NUcaXwLEGlXgv5hVaspU7gzT9ztM='
WHERE
key_id = 'a88f39a4f5ea23fe49e7a6832383b297b6bec11deab5a4c17a1787805843738a'
AND (
token = '6+ly4TeSu5UwYq4NUcaXwLEGlXgv5hVaspU7gzT9ztM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)