UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7LIAxPfXZsbKyHswWyEsZJ9lounG/U/2ve0LXchtdvs='
WHERE
key_id = 'c580862c184933382f6ce4d09a950f49e73794e9e1c88f3d39138de6b6c805a2'
AND (
token = '7LIAxPfXZsbKyHswWyEsZJ9lounG/U/2ve0LXchtdvs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)