UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'hbb6qCldoXZt3R31eCB2S9L5SuFjaNxqZZZYvflY2Gs=' 
WHERE 
  key_id = '81b4825852c278c8d9bf846a5117480aa0aa7b3037b236750459d947f9e555a9' 
  AND (
    token = 'hbb6qCldoXZt3R31eCB2S9L5SuFjaNxqZZZYvflY2Gs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022