UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zqOLRyJUO0lwOQn39E9DnMxEk7C6niBhfZjNtELXORU='
WHERE
key_id = '7b70c47bdd34da384703b1e739c9e565a817bdaed17d320efb804dffae15c32b'
AND (
token = 'zqOLRyJUO0lwOQn39E9DnMxEk7C6niBhfZjNtELXORU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)