UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'e61UZSQHwP0NVf6M2ZjD5wj5x1sbTGUu3F/MzOsrNsw=' 
WHERE 
  key_id = '07456b9390b84d1104521d66a26b356adc8a488816b4e73c011da48d550f6018' 
  AND (
    token = 'e61UZSQHwP0NVf6M2ZjD5wj5x1sbTGUu3F/MzOsrNsw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00123