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