UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'gLbWVVJRNEhJ/Lch8zKNH/CZ8F/lSfWKkaeC3BdXzFs=' 
WHERE 
  key_id = 'da2f2bdbf0984342b2469fb132f004d197d633044385ca2ed7a4370eebe98988' 
  AND (
    token = 'gLbWVVJRNEhJ/Lch8zKNH/CZ8F/lSfWKkaeC3BdXzFs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022