UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZHIArlP+gGGksz3pptQ3jLp6VW0FndixgLcebsm/sNc='
WHERE
key_id = '7c704d14c79d48341bf8d0554c97a626ea04f5d49ef4f5ef90b09de9a7189027'
AND (
token = 'ZHIArlP+gGGksz3pptQ3jLp6VW0FndixgLcebsm/sNc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)