UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'W2gM2sXbUu2KhsNBpvEOC0IF1+wW5FakVvMG7sffgFg=' 
WHERE 
  key_id = '2c4390aae6108547a5979c83a578ca78645e5b898b0c3ebf72f056957ca675a9' 
  AND (
    token = 'W2gM2sXbUu2KhsNBpvEOC0IF1+wW5FakVvMG7sffgFg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047