UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Oj+JI5knzA/z72Uhkdx9p6/9V8bBO9/asenNWjxTTG4='
WHERE
key_id = '02fa8a6bfaadf507eea54da2d030369361035b247d7d8f46e0eb4b0ccf3bdf97'
AND (
token = 'Oj+JI5knzA/z72Uhkdx9p6/9V8bBO9/asenNWjxTTG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)