UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HbVP2/WXf+PR9zH4bLFWEysFTW+bL5it09kW7POeVUg=' 
WHERE 
  key_id = '5e115698e52e97ad9e9ce923496d0964b76f80e897caf5878e99419f1e8fd292' 
  AND (
    token = 'HbVP2/WXf+PR9zH4bLFWEysFTW+bL5it09kW7POeVUg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022