UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9txmSFL3Uh6dkF/k4CpN28CK33GVn6tLlHU8/MwwOrM='
WHERE
key_id = 'e1ea4492872983e46cfcd2573e400a699bc6a786cabf8a13a68788d4c12e12a5'
AND (
token = '9txmSFL3Uh6dkF/k4CpN28CK33GVn6tLlHU8/MwwOrM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)