UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TJgAnEvpAdmcxoVdw+yBcDiQcGg1AB48bPgh9EKPydw='
WHERE
key_id = 'dd705dba9f4c4d8e009f01802bd6d8cfe596571b85f1e7a94d4d53b885b9dd50'
AND (
token = 'TJgAnEvpAdmcxoVdw+yBcDiQcGg1AB48bPgh9EKPydw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)