UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3f/gA5FF7kG9AekzwOY+EEpf9qqpPuhZkX5KulKkJjs='
WHERE
key_id = '94731f46680b899a3022f60a3ce1d8f3b9f0af2d601948f9f818af165455a19e'
AND (
token = '3f/gA5FF7kG9AekzwOY+EEpf9qqpPuhZkX5KulKkJjs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)