UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jtpB4e+eKlcx5wLI9cPa9sb6acPjf9IadHMscflOWm4='
WHERE
key_id = '3acba55e5ab213e98cb663b28481670e56e84603c55330e88524b7b8faee4197'
AND (
token = 'jtpB4e+eKlcx5wLI9cPa9sb6acPjf9IadHMscflOWm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)