UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'breeLE/Hm6V3UfP0Jj6OHH+ZBc/TUVB5SEhQUvg+CuA=' 
WHERE 
  key_id = '2a8322f10990af6bdc7ea10203fb45699b80526f0f204ca9d45d642937110d87' 
  AND (
    token = 'breeLE/Hm6V3UfP0Jj6OHH+ZBc/TUVB5SEhQUvg+CuA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027