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