UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Fqvj6yrV4321OLagbz5MbMuFuqTkJ8PpTGsKE1LmvRY=' 
WHERE 
  key_id = '485f3b4af855f52ff8eb2865ca76e8dfd4f2eb611b03bb6a34f61ab867f9f64f' 
  AND (
    token = 'Fqvj6yrV4321OLagbz5MbMuFuqTkJ8PpTGsKE1LmvRY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023