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