UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'oZIgZn84GmM9Dady2F8Gk6q5+kjusEKoB3dXZKOCrB4=' 
WHERE 
  key_id = 'ddb72a71576fa113ec3f5f84355023b90e6ab1169d10b4fb297e90dc17f363ad' 
  AND (
    token = 'oZIgZn84GmM9Dady2F8Gk6q5+kjusEKoB3dXZKOCrB4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022