UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'QQe+MgJYd71Uqaq7Q+P7180xuARWcXjDlcHze1JwYuI=' 
WHERE 
  key_id = 'e5b061f1cd8f0b0e3466f82aa01a8de9c09c77af764d5e7f77baf8e433c72b5f' 
  AND (
    token = 'QQe+MgJYd71Uqaq7Q+P7180xuARWcXjDlcHze1JwYuI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021