UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'KcbmpuT9k9ZH8/HoxvPOeFm2UBYOQ8x5Awo6S/7HA10=' 
WHERE 
  key_id = '73e0003b523a7bb2c45d49d0d87009b4e7cbc78137daa8ef4251662556519865' 
  AND (
    token = 'KcbmpuT9k9ZH8/HoxvPOeFm2UBYOQ8x5Awo6S/7HA10=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033