UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QmhkC2kIL5KL6U0fvnQYISh/EMO2DSkHBiNTeztfdgw='
WHERE
key_id = '5704d6c3302a76eb95ca0a598e75de2b60f49af0f8c3d913f8c09f2118ec47e0'
AND (
token = 'QmhkC2kIL5KL6U0fvnQYISh/EMO2DSkHBiNTeztfdgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)