UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ghAzffxOs6RJdC2xrwDHgxVJHmtAtkqmHO6nDyVTGkE='
WHERE
key_id = '1fdc123bfc702a77086f83f5acd33379d440f172b86ab5637bb742a56e69cf85'
AND (
token = 'ghAzffxOs6RJdC2xrwDHgxVJHmtAtkqmHO6nDyVTGkE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)