UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HDZ9zKGJfE4ieE2iuCD1UYLnEEi5czELKquMEDUmvDM='
WHERE
key_id = '3496780ce572f0620b1afdbc2c8d1a4e6a12193bc0089d821226d7c3be384744'
AND (
token = 'HDZ9zKGJfE4ieE2iuCD1UYLnEEi5czELKquMEDUmvDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)