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